/*
*	pctimeclock.e - Various macros used with PC Time Clock
*	Version 1
*
*	This source file is the source of a compiled macro that runs under the Epsilon (see note) text editor.
*
*	Incorporating the macro into Epsilon:
*	-------------------------------------
*	Load file into Epsilson
*	Execute:  Compile-Buffer --	Macros will be compiled and loaded
*	Save STATE and SESSION to make permanent
*
*   Note: "Epsilon" is a registered trademark licensed to Lugaru Software, Ltd.  EEL" and "Lugaru" are trademarks of Lugaru Software,
*	"Ltd. 
*
*	Using the macros:
*	----------------
*	pcTimeclock_detail_format()		Converts the Exported output of PC TIme Clock to a format that I like to use in Excel.
*	
*	Created:
*	2006-0117 Ira Gershenhorn 
*	
*	Updated:
*	2004-0424 IG pcTimeClock_detail_format updated.
*        
*/
#include "eel.h"

command pcTimeclock_detail_format()
{
	// need to also convert mm/dd/yyyy to yyyymmdd. Nothing in
	// mm/dd/yyy format will format in Excel when I've got it as
	// yyyymmdd.
	point=0; string_replace( "<Min>^(.+)-", "#1	", REGEX );
//	point=0; string_replace( "2004 ", "2004	", 0 );
	point=0; string_replace( "(..)%/(..)%/(....) ", "#3-#1-#2	", REGEX  );
//  replace tab before RYE or 320 with :
	point=0; string_replace( "	(RYE|320)$", ":#1", REGEX  );
}
